package xyz.labmem.main.modular.app.gmjj.mapper

import org.apache.ibatis.annotations.Select
import org.springframework.stereotype.Repository
import xyz.labmem.base.core.entity.ModuleVo
import xyz.labmem.main.modular.app.gmjj.entity.App_fgwsgdqy
import xyz.labmem.main.modular.common.mapper.AppBaseMapper

/**
 * @Author lty
 * @Date 2022/1/21 17:46
 */
@Repository
interface App_fgwsgdqy_Mapper : AppBaseMapper<App_fgwsgdqy>{
    @Select("select \${cloum} as name,count(1) as value from fgw_sgdqy group by \${cloum}  order by \${cloum} ")
    fun selectCountByTable(clomn : String) : ArrayList<ModuleVo>

    @Select("select sum(bdz1000kvys) bdz1000kvys,sum(bdz750kv) bdz750kv,sum(bdz500kv) bdz500kv,sum(bdz220kv) bdz220kv,sum(bdz110kv) bdz110kv,sum(bdz110kvyx) bdz110kvyx from fgw_sgdqy")  //where tbrq like concat('#{date}, '%')
    fun selectChart(date : String) : App_fgwsgdqy
}